package com.aier.bean.purchase;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.annotation.write.style.HeadStyle;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.VerticalAlignment;

/**
 * 采购输出到excel的bean
 */

@Data
@NoArgsConstructor
@AllArgsConstructor
@ContentRowHeight(25)
@HeadStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
public class PurchaseExcelBean {

    @ExcelProperty(value = "型号")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(50)
    private String modelName;

    @ExcelProperty(value = "合同编号")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(50)
    private String contractCode;

    @ExcelProperty(value = "业务员")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(30)
    private String salesperson;

    @ExcelProperty(value = "下单数量")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(30)
    private Integer orderQty;

    @ExcelProperty(value = "已到货数量")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(30)
    private Integer arrivedQty;

    @ExcelProperty(value = "剩余未到货数量")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(30)
    private Integer remainingQty;

    @ExcelProperty(value = "备注")
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER, verticalAlignment = VerticalAlignment.CENTER)
    @ColumnWidth(50)
    private String remark;
}
